Excel VBA programming with Excel to compute the load tranceverse distribution coefficient of G-M method
نویسندگان
چکیده
منابع مشابه
Programming Excel with VBA and .NET - solve real-world problems with Excel
by Jeff Webb : Programming Excel with VBA and .NET: Solve Real-World Problems with Excel ISBN : #0596007663 | Date : 2006-05-05 Description : PDF-716bf | Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining exist...
متن کاملToward Reverse Engineering of VBA Based Excel Spreadsheet Applications
Modern spreadsheet systems can be used to implement complex spreadsheet applications including data sheets, customized user forms and executable procedures written in a scripting language. These applications are often developed by practitioners that do not follow any software engineering practice and do not produce any design documentation. Thus, spreadsheet applications may be very difficult t...
متن کاملAssessing Excel VBA Suitability for Monte Carlo Simulation
Monte Carlo (MC) simulation includes a wide range of stochastic techniques used to quantitatively evaluate the behavior of complex systems or processes. Microsoft Excel spreadsheets with Visual Basic for Applications (VBA) software is, arguably, the most commonly employed general purpose tool for MC simulation. Despite the popularity of the Excel in many industries and educational institutions,...
متن کاملCalculation of a distribution free estimate of effect size and confidence intervals using VBA/Excel
Reporting effect sizes aids the transparent presentation and independent interpretation of scientific data. However, calculation and reporting of effect sizes for data obtained in basic research is rare. A standardized effect size was reported by Norman Cliff, known as Cliff's delta. It has several advantageous features, as (i) it makes no assumption on the shape of the underlying distribution,...
متن کاملDynamic Programming from an Excel Perspective
Many students have difficulty understanding the concept of dynamic programming, a problem solving approach appropriate to use when a problem can be broken down into overlapping sub-problems. In addition, computer science majors seldom take a course in which a spreadsheet application is taught or used, although spreadsheet applications can be a great tool in visualizing and solving problems. Thi...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Journal of Physics: Conference Series
سال: 2021
ISSN: 1742-6588,1742-6596
DOI: 10.1088/1742-6596/1941/1/012026